﻿//using HSGDcIS.Model.Models.HSGD_Family;
//using HSGDcIS.Services.BASE;
//using HSGDcIS.IRepository.Base;
//using System.Threading.Tasks;
//using System.Collections.Generic;
//using HSGDcIS.Model.Models;

//namespace HSGDcIS.Services.HSGD_Family {
//    public class ChildMainServices : BaseServices<ChildMain>, IChildMainServices {
//        private readonly IBaseRepository<ChildMain> _dal;
//        public ChildMainServices(IBaseRepository<ChildMain> dal) {
//            this._dal = dal;
//            base.BaseDal = dal;
//        }

//        public async Task<List<ChildMain>> GetChilds(int enrollment_year, string center_name) {
//            //base.
//            //var res = (await base.QuerySql($"SELECT * FROM ChildMain('{enrollment_year}','{center_name}')"));
//            var res = (await base.QuerySql($"SELECT * FROM rpt_enr_tce('{enrollment_year}','10/1/{enrollment_year - 1}','','{center_name}')"));
//            //return res;
//            //var res = await _dal.QuerySql($"SELECT * FROM dbo.ChildMain('{enrollment_year}','{center_name}')");
//            //var a =  _dal.Db.Queryable<child_enrollment>();   
//            //_dal.Db.ContextID
//            //var res = await _dal.QuerySql($"SELECT * FROM dbo.ChildMain WHERE enrollment_year=2023");
//            //var res = await BaseDal.Query();
//            //var result = _mapper.Map<PersonDto>(person);
//            return res;
//        }
//    }
//}